package com.servlet;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.SimpleDateFormat;
import java.util.Date;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import com.bean.LoginBean;

public class qiandao extends HttpServlet {

	
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		    request. setCharacterEncoding("UTF-8");
		    HttpSession session = request.getSession();
		    LoginBean bean =new LoginBean();
		    bean=(LoginBean) session.getAttribute("Loginbean");
		    String username=bean.getUsername();
		    java.util.Date now = new Date();
		    SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
			SimpleDateFormat timeFormat = new SimpleDateFormat("HH:mm:ss");
			String time = timeFormat.format(now);
			String date = dateFormat.format(now);
		    try {
			Class.forName("com.mysql.jdbc.Driver");
		    } catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		    }
		   String url ="jdbc:mysql://localhost:3306/graduatedesign" ;
			  Connection conn = null ;
			  Statement stmt = null ;
			  ResultSet rs = null;
			  String sql="insert into kaoqin (username,qiandao,date) values (?,?,?)"; 
			  try {
				conn = DriverManager.getConnection(url, "root", "root") ;
				stmt = conn.createStatement() ;
				PreparedStatement preStmt=conn.prepareStatement(sql);  
				preStmt.setString(1, username); 
				preStmt.setString(2, time);
				preStmt.setString(3, date); 
	            int suc = preStmt.executeUpdate(); 
	            if(suc!=0){
	            	response.sendRedirect("admin/daka.jsp") ;
	            }
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}	 	   
	}

	
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		doGet(request, response);
	}
	
}
